
APAR= II09219
CAWIN RUMBA/400 DATABASE ACCESS


** Last updated 5/22/96 **


** NOTE **
Because the brackets are unable to display/print properly,
all brackets have been changed to be greater than/less than
signs.  For example, <RUMBASQL> should really be in brackets.


RUMBA/400 for Database Access
_____________________________

1. If you receive error "SQLIBM foreign application does not
   accept data" while using Database Access and specifying
   output to Excel, apply PTF SF29790 (SBCS) or PTF SF29853
   (DBCS).

2. Drop down list on the Database Access screen
   shows "This is a sample" in English.  This fix
   can be applied in any one of three possible ways:

A.  Install Database Access - recommended for new DBA users.

The file RUMBASQL.TXT is installed into the windows directory on
the user's hard drive.  Database Access queries are kept in this
file.

WARNING!!!  WARNING!!!
WARNING!!!  If you have previously created Database Access
WARNING!!!  queries and saved them to this file, then
WARNING!!!  re-installation will delete them!  This will
WARNING!!!  apply the fix, but you can lose previously
WARNING!!!  saved DBA queries.
WARNING!!!  WARNING!!!


B.  Delete lines from RUMBASQL.TXT - recommended for current
    users.

For customers who have already installed Database Access but
want to keep saved queries in RUMBASQL.TXT, we have a simple
solution.  Open the RUMBASQL.TXT file in your windows directory
using an editor like Notepad or Edit and delete the lines
described as "sample."  For example the following lines are
removable:

#This is a sample
 Tag=SAMP,Destination=Grid
 SELECT * FROM LIBRARY.TABLE
#Sample1
 Tag=SMP1,Destination=Grid
 select name, address
 from company.employee
#Sample2
 Tag=SMP2,Destination=Grid
 select <@name>
 from company.employee
 where id = <employee_id>


C.  Copy RUMBASQL.TXT from the AS400 onto your PC.

For customers who prefer not to re-install Database Access, and
who do not have queries saved in RUMBASQL.TXT which they wish to
keep, there is a third way to apply this fix.  Copy the
RUMBASQL.TXT file from your AS400 (QPWXCWN directory) into the
windows directory on your hard drive.  If you have saved queries
in RUMBASQL.TXT which you would like to keep, choose option (B)
from above.



Localizing RUMBA Database Access for Microsoft Excel & Word
___________________________________________________________


I. Introduction

This technical document provides information on how to localize
RUMBA Database Access.  You must already have RUMBA Database
Access installed on your computer.  Microsoft applications are
translated into numerous languages.  The user interfaces and the
behaviors are changed to fulfill the needs of the targeted local
market.  The following lists the differences in international
versions of Microsoft Excel and Microsoft Word that will affect
the behavior of RUMBA Database Access.

- International versions of Microsoft Excel use different
  notations for R1C1 reference type.
- International versions of Microsoft Excel and Word menu
  commands are translated.


II. Microsoft Excel Instructions

Check to make sure that your Microsoft Excel will respond to
dynamic data exchange (DDE) requests from Rumba Database Access
by verifying that Remote References are enabled.  To do this
follow the steps below.

1.  From the Tools menu, choose Options.
2.  Choose the Calculation tab and confirm that the Update
    Remote References check box in the Workbook Options is
    selected.
3.  Choose the OK button.

Check the Microsoft Excel Tab in order to use it in the final
step.
4.  Note the name on the tab located at the bottom of the
    workbook window.  (English uses "Sheet").

Check the Microsoft Excel Reference Style in order to use it in
the final step.
5.  From the Tools menu, choose Options.
6.  Choose the General tab and note the Reference Style.
    (English uses "R1C1").
7.  Choose the OK button.

8.  Finally, edit the RUMBA.INI file in the CAWIN directory to
    include the workspace name and reference type notation under
    the <RUMBASQL> heading.

 English example:  German example:  French example:
 Excel1=Sheet      Excel1=Tab       Excel1=Feuil
 Excel2=R1C1       Excel2=Z1S1      Excel2=L1C1

Note:
If the workspace name or reference type is not specified the
default is English.


III. Microsoft Word Instructions

Check the Microsoft Word document name in order to use it in the
final step.

1.  Note the Title Bar of a new document.  (English uses
    "Document").

Check the Microsoft Word Insert and File menu in order to use it
in the final step.
2.  Note the fourth word used in the Menu Bar. (English uses
    "Insert").
3.  Note the first word used in the Menu Bar. (English uses
    "File").

Check the Microsoft Word Document New command in order to use it
in the final step.
4.  From the File menu note the first command option in the
    list.  (English uses "New").

Check the Microsoft Word Document Template Description in order
to use it in the final step.  To do this follow the steps below.
5.  From the File menu, choose New.
6.  Note the document template description at the bottom of the
    dialog box.  (English uses "Default").
7.  Choose the OK button.

8.  Finally, edit the RUMBA.INI file in the CAWIN directory to
    include the workspace name, menu commands, and document
    template description under the <RUMBASQL> heading.

 English example:  German example:  French example:
 Word1=Document    Word1=Dokument   Word1=Document
 Word2=Insert      Word2=Einf gen   Word2=Insertion
 Word3=File        Word3=Datei      Word3=Fichier
 Word4=New         Word4=Neu        Word4=Nouveau
 Word5=Default     Word5=Standard   Word5=Mod le

Note:
If the workspace name, menu commands, or document template is
not specified the default is English.

